Formula2

  1. Create a new formula called Formula2.
  2. Type the following in the Formula text box of the Formula Editor:

    If ToText({customer,CUSTOMER ID}) [1] = "6" Then

        "TRUE"

    Else

        "FALSE"

  3. Click Check to test for errors. You will receive the following error message:

    This field name is not known.

  4. Correct the formula by replacing the comma (,) in the field name with a period (.).
  5. Click Check again. The formula should now be error-free.
  6. Place the formula to the right of the @Formula1 field.
  7. Click Print Preview on the Standard toolbar to check the values in the report and compare the fields to see if the field values returned by @Formula2 are correct.

You should see "TRUE" next to all customer numbers that begin with 6 and "FALSE" next to all customer numbers that do not begin with 6.

Go on to Formula3.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com